Jassif Team Institution

let mysql = require('mysql');

let con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  con.query("CREATE DATABASE mydb", function (err, result) {
    if (err) throw err;
    console.log("Database created");
  });
});

C:\Users\Your Name>node demo_create_db.js

Connected!
Database created

con.query("CREATE DATABASE IF NOT EXISTS mydb", function (err, result) {
  if (err) throw err;
  console.log("Database created or already exists");
});

let con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword",
  database: "mydb"  // Specify the database to use
});

con.query("SHOW DATABASES", function (err, result) {
  if (err) throw err;
  console.log("Databases:");
  result.forEach(row => {
    console.log(row.Database);
  });
});

const mysql = require('mysql');

// Create connection
const con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "password"
});

// Connect to MySQL
con.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL:', err.message);
    return;
  }
  
  console.log('Connected to MySQL server');
  
  // Create database if not exists
  const dbName = 'company_db';
  con.query(`CREATE DATABASE IF NOT EXISTS ${dbName}`, (err, result) => {
    if (err) {
      console.error('Error creating database:', err.message);
      con.end();
      return;
    }
    
    console.log(`Database '${dbName}' created or already exists`);
    
    // Switch to the created database
    con.query(`USE ${dbName}`, (err) => {
      if (err) {
        console.error('Error switching database:', err.message);
        con.end();
        return;
      }
      
      console.log(`Using database: ${dbName}`);
      
      // Now you can create tables and perform other operations
      // ...
      
      // Close connection
      con.end((err) => {
        if (err) {
          console.error('Error closing connection:', err.message);
          return;
        }
        console.log('Connection closed');
      });
    });
  });
});